#​614 — September 4, 2025

Web Version

Together with  Redgate

Postgres Weekly

🗓️ pgcalendar: 'Infinite' Calendar Functionality for Recurring Schedules — If you need to store schedules for events, potentially with exceptions (like holidays or cancellations), this extension provides a way to model those concepts. Examples.

Huseyin Akbas

A Quirk of Partitioned Table Statistics — Postgres relies on partitioned table stats to estimate join row counts, but autovacuum won’t collect them, meaning you need to run ANALYZE explicitly for good plans.

Laurenz Albe

Monitor PostgreSQL with Confidence — Redgate Monitor gives you real-time insights, intelligent alerts, and deep diagnostics for your PostgreSQL databases. Stay ahead of performance issues and keep your systems running smoothly. Explore Redgate Monitor.

Redgate sponsor

IN BRIEF:

Optimizing Cold Page Reads in Postgres — Useful tuning tips if your apps have non-traditional access patterns that don’t benefit from caching.

Tej Kashi

📄 The Hidden Bottleneck in Postgres Restores and its Solution Warda Bibi

📄 Automated Postgres Backups in Docker: Complete Guide with pg_dump Servers Inc.

📄 Best Practices for Securing Postgres in Hybrid Environments Sebastian Insausti (Severalnines)

RELEASES:

🌐 PostGIS 3.6.0 Released — The popular extension for adding powerful geospatial data processing support to Postgres now targets Postgres 18 (currently at RC1).

PostGIS PSC and OSGeo

E-Maj 4.7: Fine-Grained Write Logging and Time Travel Extension — An extension that traces updates performed on tables which can then be used to perform ‘time travel’ on subsets of your database. v4.7 brings Postgres 18 support, including support for virtual generated columns. (TIL E-Maj stands for “Enregistrement des Mises à Jour”, that is “recording of updates”.)

Philippe Beaudoin

pg_csv: Flexible CSV Processing Extension — Designed to resolve some of the problems with COPY’s CSV support.

PostgREST Team

Jailer 16.9: Database Subsetting and Relational Data Browsing Tool — Navigate bidirectionally through databases by following foreign-key-based or user-defined relationships. Built in Java and supports most relational databases via JDBC.

Wisser